Database Installation Instructions and Schema

Overview

Oracle Insurance Rule Workbench (OIRW) maintains its own schema for user management and environment information storage. This schema also holds the mappings between users and their associated environments. OIRW implements custom roles and privileges—such as build manager, configurer, and system administrator—to control user access according to their assigned roles.

Pre-requisites

For installing the database according to your technology stack, please refer to 12.2.0.0 Database Installation Instructions

Run SQL*Plus

Run SQL*Plus as a user with DBA privileges by running the following command:

sqlplus / as sysdba

Create Users

Create Oracle users for the Oracle Insurance Rules Workbench schema by running the following commands in an SQL*Plus session:

SQL Scripts

create user <OIRW Username> identified by <OIRW Password>;
grant connect, resource to <OIRWUsername>;
grant UNLIMITED TABLESPACE to <OIRWUsername>;
grant CREATE TABLE to <OIRWUsername>;

Scripts to Execute on Databases

For Oracle Insurance Rules Workbench Release V12.2.0, migration scripts are included with the media pack and should be run after successfully creating the schema.

  • Copy the following script files from the Palette distribution ZIP/scripts directory as per the stack.

  • Copy the migration script from "palette-distribution\scripts\central\oracle"—Execute the migration scripts "OIRW-12.1.0.0 migrate.sql" and "OIRW-12.2.0.0 migrate.sql" on the OIRW central schema.

  • Copy the migration script from "palette-distribution\scripts\oipa\oracle" - Execute the migration scripts "OIRW-12.1.0.0 migrate.sql" and "OIRW-12.2.0.0 migrate.sql" on the OIPA schema.

  • Copy the migration script from "palette-distribution\scripts\ivs\oracle" - Execute the migrate script "OIRW-12.2.0.0 migrate.sql" on IVSSchema.

Note: OIPA/IVS changes will be taken care of by the upgrade utility. For reference, the above scripts for OIPA and IVS will help for verification.